Notes/Domino 6 and 7 Forum : RE: ODBC from a button in a form

Notes/Domino 6 and 7 Forum

RE: ODBC from a button in a form

RE: ODBC from a button in a form
Posted by ~Olga Dwotumiader on 19.Jan.04 at 10:52 AM using a Web browser
Category: Domino Designer

Release: All Releases

Platform: All Platforms

Hello,

you should search this forum for "ODBC"....

But anyway: Here is some sample code (untested!)

Uselsx "*LSXODBC"

Dim conn As ODBCConnection
Dim query As ODBCQuery
Dim result As ODBCResultSet

Set conn = New ODBCConnection
Set query = New ODBCQuery
Set result = New ODBCResultSet

If(conn.ConnectTo("MyDSN")) Then
Set query.Connection = conn
Set result.Query = query
End If

query.SQL = "SELECT * FROM MyTable WHERE [MyKey] = '12345'"
Call result.Execute
If (result.IsResultSetAvailable) Then
...
End If

HTH

Kuwe